﻿<?xml version="1.0" encoding="utf-8"?><Articles><Article><ArticlesID>550</ArticlesID><Title>SQL Server 2008 Designer Behavior Change: Saving Changes Not Permitted</Title><Body>&amp;lt;p&amp;gt;Khắc phục lỗi &amp;lt;strong&amp;gt;Saving Changes Not Permitted&amp;lt;/strong&amp;gt; khi Design Table trong &amp;lt;strong&amp;gt;SQL&amp;amp;nbsp;Server 2008&amp;lt;/strong&amp;gt;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;Warning Message:&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;em&amp;gt;Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.&amp;lt;/em&amp;gt;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;img width=&amp;quot;452&amp;quot; height=&amp;quot;356&amp;quot; border=&amp;quot;0&amp;quot; alt=&amp;quot;SQL Server 2008 Designer Behavior Change: Saving Changes Not Permitted&amp;quot; style=&amp;quot;border: 0px none ;&amp;quot; src=&amp;quot;http://dev.meotom.net/Uploads/admin/2009/10/26/image_4.png&amp;quot; /&amp;gt;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;V&amp;amp;agrave;o Tools -&amp;amp;gt; Options --&amp;amp;gt; Designer --&amp;amp;gt; uncheck &amp;amp;quot;Prevent saving changes that require table re-creation&amp;amp;quot;.&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;&amp;lt;img width=&amp;quot;550&amp;quot; height=&amp;quot;312&amp;quot; border=&amp;quot;0&amp;quot; alt=&amp;quot;SQL Server 2008 Designer Behavior Change: Saving Changes Not Permitted&amp;quot; style=&amp;quot;border: 0px none ;&amp;quot; src=&amp;quot;http://dev.meotom.net/Uploads/admin/2009/10/26/image_2.png&amp;quot; /&amp;gt;&amp;lt;/p&amp;gt;
&amp;lt;p&amp;gt;-- Brian Knight- pragmaticworks&amp;lt;/p&amp;gt;</Body><CommentEnabled>True</CommentEnabled><ViewCount>0</ViewCount><ReleaseDate>10/26/2009 10:13:29 AM</ReleaseDate><TotalComment>0</TotalComment><IsMedia>False</IsMedia><IsPicture>False</IsPicture><IsVote>True</IsVote><ArticlePassword /><PostVisible>0</PostVisible><ArticlePath>/2009/10/26/SQL-Server-2008-Designer-Behavior-Change-Saving-Changes-Not-Permitted-226</ArticlePath><Approved>True</Approved><ImagePath /><CategoryId>35</CategoryId><ArrayCatID>35|25</ArrayCatID></Article></Articles>